Dataset statistics
| Number of variables | 21 |
|---|---|
| Number of observations | 1796 |
| Missing cells | 108 |
| Missing cells (%) | 0.3% |
| Duplicate rows | 12 |
| Duplicate rows (%) | 0.7% |
| Total size in memory | 592.2 KiB |
| Average record size in memory | 337.7 B |
Variable types
| NUM | 18 |
|---|---|
| CAT | 3 |
Reproduction
| Analysis started | 2023-11-23 13:47:47.537203 |
|---|---|
| Analysis finished | 2023-11-23 13:49:17.104208 |
| Version | pandas-profiling v2.5.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download configuration | config.yaml |
| Dataset has 12 (0.7%) duplicate rows | Duplicates |
SPB1__Motor__Temperature has a high cardinality: 1662 distinct values | High cardinality |
X__Axis__Drive_Load has a high cardinality: 623 distinct values | High cardinality |
X__Motor__Torque has a high cardinality: 615 distinct values | High cardinality |
C1__Axis__Speed is highly correlated with C1__Axis__Actual_Feed_Rate | High Correlation |
C1__Axis__Actual_Feed_Rate is highly correlated with C1__Axis__Speed | High Correlation |
C1__Motor__Power is highly correlated with C1__Axis__Rotary_Speed | High Correlation |
C1__Axis__Rotary_Speed is highly correlated with C1__Motor__Power | High Correlation |
C1__Motor__Torque is highly correlated with C1__Motor__Current | High Correlation |
C1__Motor__Current is highly correlated with C1__Motor__Torque | High Correlation |
SPB1__Axis__Position is highly correlated with C1__Axis__Position | High Correlation |
C1__Axis__Position is highly correlated with SPB1__Axis__Position | High Correlation |
SPB1__Motor__Current is highly correlated with SPB1__Axis__Drive_Load and 2 other fields | High Correlation |
SPB1__Axis__Drive_Load is highly correlated with SPB1__Motor__Current and 2 other fields | High Correlation |
SPB1__Motor__Power is highly correlated with SPB1__Axis__Drive_Load and 2 other fields | High Correlation |
SPB1__Motor__Torque is highly correlated with SPB1__Axis__Drive_Load and 2 other fields | High Correlation |
X__Axis__Position is highly correlated with SPB1__Axis__Speed | High Correlation |
SPB1__Axis__Speed is highly correlated with X__Axis__Position | High Correlation |
X__Motor__Current is highly skewed (γ1 = 29.87847993) | Skewed |
C1__Axis__Actual_Feed_Rate has 1190 (66.3%) zeros | Zeros |
C1__Axis__Position has 18 (1.0%) zeros | Zeros |
C1__Axis__Rotary_Speed has 111 (6.2%) zeros | Zeros |
C1__Axis__Speed has 1190 (66.3%) zeros | Zeros |
C1__Motor__Power has 1193 (66.4%) zeros | Zeros |
SPB1__Axis__Drive_Load has 345 (19.2%) zeros | Zeros |
SPB1__Axis__Rotary_Speed has 321 (17.9%) zeros | Zeros |
SPB1__Axis__Speed has 324 (18.0%) zeros | Zeros |
SPB1__Motor__Current has 395 (22.0%) zeros | Zeros |
SPB1__Motor__Power has 393 (21.9%) zeros | Zeros |
SPB1__Motor__Torque has 395 (22.0%) zeros | Zeros |
X__Axis__Rotary_Speed has 250 (13.9%) zeros | Zeros |
X__Motor__Current has 19 (1.1%) zeros | Zeros |
| Distinct count | 1662 |
|---|---|
| Unique (%) | 92.7% |
| Missing | 4 |
| Missing (%) | 0.2% |
| Memory size | 14.2 KiB |
| 56.511948 | 2 |
|---|---|
| 56.66504 | 2 |
| 47.085648 | 2 |
| 46.962456 | 2 |
| 57.476868 | 2 |
| Other values (1657) |
| Value | Count | Frequency (%) | |
| 56.511948 | 2 | 0.1% | |
| 56.66504 | 2 | 0.1% | |
| 47.085648 | 2 | 0.1% | |
| 46.962456 | 2 | 0.1% | |
| 57.476868 | 2 | 0.1% | |
| 53.90001 | 2 | 0.1% | |
| 57.025146 | 2 | 0.1% | |
| 49.90001 | 2 | 0.1% | |
| 56.185993 | 2 | 0.1% | |
| 44.301445 | 2 | 0.1% | |
| Other values (1652) | 1772 | 98.7% | |
| (Missing) | 4 | 0.2% |
Length
| Max length | 11 |
|---|---|
| Mean length | 8.547327394 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Decimal_Number | 10 | 45.5% | |
| Uppercase_Letter | 7 | 31.8% | |
| Other_Punctuation | 2 | 9.1% | |
| Lowercase_Letter | 2 | 9.1% | |
| Connector_Punctuation | 1 | 4.5% |
| Value | Count | Frequency (%) | |
| Common | 13 | 59.1% | |
| Latin | 9 | 40.9% |
| Value | Count | Frequency (%) | |
| ASCII | 22 | 100.0% |
| Distinct count | 14 |
|---|---|
| Unique (%) | 0.8% |
| Missing | 4 |
| Missing (%) | 0.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -1064.154221 |
|---|---|
| Minimum | -4086.72 |
| Maximum | 11160 |
| Zeros | 1190 |
| Zeros (%) | 66.3% |
| Memory size | 14.2 KiB |
Quantile statistics
| Minimum | -4086.72 |
|---|---|
| 5-th percentile | -3819.5996 |
| Q1 | -3819.5996 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 11160 |
| Range | 15246.72 |
| Interquartile range (IQR) | 3819.5996 |
Descriptive statistics
| Standard deviation | 1957.887552 |
|---|---|
| Coefficient of variation (CV) | -1.839853203 |
| Kurtosis | 6.132382322 |
| Mean | -1064.154221 |
| Median Absolute Deviation (MAD) | 1614.816906 |
| Skewness | 0.5920442404 |
| Sum | -1906964.364 |
| Variance | 3833323.668 |
| Value | Count | Frequency (%) | |
| 0 | 1190 | 66.3% | |
| -3819.5996 | 515 | 28.7% | |
| -325.42502 | 61 | 3.4% | |
| -3819.6 | 9 | 0.5% | |
| 11160 | 8 | 0.4% | |
| -4086.72 | 1 | 0.1% | |
| 8308.906 | 1 | 0.1% | |
| -60.111256 | 1 | 0.1% | |
| 1123.2 | 1 | 0.1% | |
| 5875.2 | 1 | 0.1% | |
| Other values (4) | 4 | 0.2% | |
| (Missing) | 4 | 0.2% |
| Value | Count | Frequency (%) | |
| -4086.72 | 1 | 0.1% | |
| -3819.6 | 9 | 0.5% | |
| -3819.5996 | 515 | 28.7% | |
| -325.42502 | 61 | 3.4% | |
| -141.54727 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 11160 | 8 | 0.4% | |
| 10627.2 | 1 | 0.1% | |
| 8308.906 | 1 | 0.1% | |
| 5875.2 | 1 | 0.1% | |
| 3556.9067 | 1 | 0.1% |
C1__Axis__Drive_Load
Real number (ℝ≥0)
| Distinct count | 821 |
|---|---|
| Unique (%) | 45.8% |
| Missing | 4 |
| Missing (%) | 0.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.554206036 |
|---|---|
| Minimum | 0.12817383 |
| Maximum | 20.281982 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 14.2 KiB |
Quantile statistics
| Minimum | 0.12817383 |
|---|---|
| 5-th percentile | 2.69500738 |
| Q1 | 3.129577625 |
| median | 4.6478272 |
| Q3 | 7.60803225 |
| 95-th percentile | 10.876465 |
| Maximum | 20.281982 |
| Range | 20.15380817 |
| Interquartile range (IQR) | 4.478454625 |
Descriptive statistics
| Standard deviation | 2.951323307 |
|---|---|
| Coefficient of variation (CV) | 0.5313672716 |
| Kurtosis | 0.7371347069 |
| Mean | 5.554206036 |
| Median Absolute Deviation (MAD) | 2.420284257 |
| Skewness | 1.099317315 |
| Sum | 9953.137216 |
| Variance | 8.710309264 |
| Value | Count | Frequency (%) | |
| 2.9296875 | 12 | 0.7% | |
| 3.2287598 | 12 | 0.7% | |
| 2.947998 | 11 | 0.6% | |
| 3.0273438 | 10 | 0.6% | |
| 3.2043457 | 10 | 0.6% | |
| 2.9785156 | 9 | 0.5% | |
| 2.8564453 | 9 | 0.5% | |
| 2.923584 | 9 | 0.5% | |
| 3.363037 | 9 | 0.5% | |
| 2.886963 | 9 | 0.5% | |
| Other values (811) | 1692 | 94.2% |
| Value | Count | Frequency (%) | |
| 0.12817383 | 1 | 0.1% | |
| 0.20141602 | 1 | 0.1% | |
| 0.8483887 | 1 | 0.1% | |
| 1.2878418 | 1 | 0.1% | |
| 1.4099121 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 20.281982 | 1 | 0.1% | |
| 20.08667 | 1 | 0.1% | |
| 18.048096 | 1 | 0.1% | |
| 17.376709 | 1 | 0.1% | |
| 15.985107 | 1 | 0.1% |
| Distinct count | 709 |
|---|---|
| Unique (%) | 39.6% |
| Missing | 4 |
| Missing (%) | 0.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -4703.76459 |
|---|---|
| Minimum | -33826.75 |
| Maximum | 1878.6045 |
| Zeros | 18 |
| Zeros (%) | 1.0% |
| Memory size | 14.2 KiB |
Quantile statistics
| Minimum | -33826.75 |
|---|---|
| 5-th percentile | -28173.29625 |
| Q1 | -5373.789375 |
| median | 119.99999 |
| Q3 | 312 |
| 95-th percentile | 1878.6045 |
| Maximum | 1878.6045 |
| Range | 35705.3545 |
| Interquartile range (IQR) | 5685.789375 |
Descriptive statistics
| Standard deviation | 9591.539775 |
|---|---|
| Coefficient of variation (CV) | -2.039119856 |
| Kurtosis | 1.457647435 |
| Mean | -4703.76459 |
| Median Absolute Deviation (MAD) | 7462.086827 |
| Skewness | -1.685886724 |
| Sum | -8429146.146 |
| Variance | 91997635.26 |
| Value | Count | Frequency (%) | |
| 1878.6045 | 202 | 11.2% | |
| 360 | 79 | 4.4% | |
| 359.99997 | 55 | 3.1% | |
| 264 | 50 | 2.8% | |
| 360.00003 | 47 | 2.6% | |
| 288 | 44 | 2.4% | |
| 312 | 43 | 2.4% | |
| 240 | 38 | 2.1% | |
| 216 | 37 | 2.1% | |
| 192 | 35 | 1.9% | |
| Other values (699) | 1162 | 64.7% |
| Value | Count | Frequency (%) | |
| -33826.75 | 1 | 0.1% | |
| -33769.457 | 1 | 0.1% | |
| -33693.062 | 1 | 0.1% | |
| -33629.402 | 1 | 0.1% | |
| -33559.38 | 2 | 0.1% |
| Value | Count | Frequency (%) | |
| 1878.6045 | 202 | 11.2% | |
| 1878.6038 | 1 | 0.1% | |
| 1852.2941 | 1 | 0.1% | |
| 1741.0477 | 1 | 0.1% | |
| 1569.2941 | 1 | 0.1% |
| Distinct count | 280 |
|---|---|
| Unique (%) | 15.6% |
| Missing | 4 |
| Missing (%) | 0.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.595420904 |
|---|---|
| Minimum | 0 |
| Maximum | 70.86549 |
| Zeros | 111 |
| Zeros (%) | 6.2% |
| Memory size | 14.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0.001021794 |
| median | 0.00332083 |
| Q3 | 24.238995 |
| 95-th percentile | 24.266584 |
| Maximum | 70.86549 |
| Range | 70.86549 |
| Interquartile range (IQR) | 24.23797321 |
Descriptive statistics
| Standard deviation | 11.93414548 |
|---|---|
| Coefficient of variation (CV) | 1.571228986 |
| Kurtosis | 2.241165827 |
| Mean | 7.595420904 |
| Median Absolute Deviation (MAD) | 10.49258414 |
| Skewness | 1.39776676 |
| Sum | 13610.99426 |
| Variance | 142.4238284 |
| Value | Count | Frequency (%) | |
| 0.000255 | 131 | 7.3% | |
| 0.000766 | 115 | 6.4% | |
| 0 | 111 | 6.2% | |
| 0.000511 | 89 | 5.0% | |
| 0.001277242 | 70 | 3.9% | |
| 0.002299036 | 70 | 3.9% | |
| 0.001021794 | 67 | 3.7% | |
| 0.001788139 | 54 | 3.0% | |
| 0.001532691 | 44 | 2.4% | |
| 0.002043588 | 38 | 2.1% | |
| Other values (270) | 1003 | 55.8% |
| Value | Count | Frequency (%) | |
| 0 | 111 | 6.2% | |
| 0.000255 | 131 | 7.3% | |
| 0.000511 | 89 | 5.0% | |
| 0.000766 | 115 | 6.4% | |
| 0.001021794 | 67 | 3.7% |
| Value | Count | Frequency (%) | |
| 70.86549 | 1 | 0.1% | |
| 70.86013 | 1 | 0.1% | |
| 70.85988 | 3 | 0.2% | |
| 70.858345 | 1 | 0.1% | |
| 70.854256 | 1 | 0.1% |
| Distinct count | 14 |
|---|---|
| Unique (%) | 0.8% |
| Missing | 4 |
| Missing (%) | 0.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -1064.161023 |
|---|---|
| Minimum | -4069.44 |
| Maximum | 11160 |
| Zeros | 1190 |
| Zeros (%) | 66.3% |
| Memory size | 14.2 KiB |
Quantile statistics
| Minimum | -4069.44 |
|---|---|
| 5-th percentile | -3819.5996 |
| Q1 | -3819.5996 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 11160 |
| Range | 15229.44 |
| Interquartile range (IQR) | 3819.5996 |
Descriptive statistics
| Standard deviation | 1957.807709 |
|---|---|
| Coefficient of variation (CV) | -1.839766414 |
| Kurtosis | 6.128511962 |
| Mean | -1064.161023 |
| Median Absolute Deviation (MAD) | 1614.793635 |
| Skewness | 0.5915515183 |
| Sum | -1906976.553 |
| Variance | 3833011.025 |
| Value | Count | Frequency (%) | |
| 0 | 1190 | 66.3% | |
| -3819.5996 | 515 | 28.7% | |
| -325.42502 | 61 | 3.4% | |
| -3819.6 | 9 | 0.5% | |
| 11160 | 8 | 0.4% | |
| 10592.64 | 1 | 0.1% | |
| 5840.64 | 1 | 0.1% | |
| 3591.4668 | 1 | 0.1% | |
| -123.73315 | 1 | 0.1% | |
| 1088.64 | 1 | 0.1% | |
| Other values (4) | 4 | 0.2% | |
| (Missing) | 4 | 0.2% |
| Value | Count | Frequency (%) | |
| -4069.44 | 1 | 0.1% | |
| -3819.6 | 9 | 0.5% | |
| -3819.5996 | 515 | 28.7% | |
| -325.42502 | 61 | 3.4% | |
| -141.54727 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 11160 | 8 | 0.4% | |
| 10592.64 | 1 | 0.1% | |
| 8343.467 | 1 | 0.1% | |
| 5840.64 | 1 | 0.1% | |
| 3591.4668 | 1 | 0.1% |
| Distinct count | 623 |
|---|---|
| Unique (%) | 34.8% |
| Missing | 4 |
| Missing (%) | 0.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.740043518 |
|---|---|
| Minimum | -13.982298 |
| Maximum | 18.245543 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 14.2 KiB |
Quantile statistics
| Minimum | -13.982298 |
|---|---|
| 5-th percentile | -9.504821 |
| Q1 | 2.60472075 |
| median | 3.3634639 |
| Q3 | 4.8381036 |
| 95-th percentile | 7.555297 |
| Maximum | 18.245543 |
| Range | 32.227841 |
| Interquartile range (IQR) | 2.23338285 |
Descriptive statistics
| Standard deviation | 4.939516369 |
|---|---|
| Coefficient of variation (CV) | 1.802714569 |
| Kurtosis | 2.056935526 |
| Mean | 2.740043518 |
| Median Absolute Deviation (MAD) | 3.016865879 |
| Skewness | -1.448961009 |
| Sum | 4910.157985 |
| Variance | 24.39882196 |
| Value | Count | Frequency (%) | |
| 2.5208127 | 16 | 0.9% | |
| 2.8992915 | 16 | 0.9% | |
| 2.927856 | 15 | 0.8% | |
| 2.7707515 | 14 | 0.8% | |
| 12.868284 | 13 | 0.7% | |
| 2.599365 | 13 | 0.7% | |
| 2.5779417 | 13 | 0.7% | |
| 2.7350461 | 12 | 0.7% | |
| 2.720764 | 12 | 0.7% | |
| 2.5636594 | 11 | 0.6% | |
| Other values (613) | 1657 | 92.3% |
| Value | Count | Frequency (%) | |
| -13.982298 | 1 | 0.1% | |
| -10.797362 | 1 | 0.1% | |
| -9.961852 | 1 | 0.1% | |
| -9.826171 | 1 | 0.1% | |
| -9.726195 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 18.245543 | 1 | 0.1% | |
| 18.074156 | 1 | 0.1% | |
| 16.188902 | 1 | 0.1% | |
| 15.567625 | 1 | 0.1% | |
| 14.289366 | 1 | 0.1% |
| Distinct count | 154 |
|---|---|
| Unique (%) | 8.6% |
| Missing | 4 |
| Missing (%) | 0.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 229.2496849 |
|---|---|
| Minimum | 0 |
| Maximum | 4601.184 |
| Zeros | 1193 |
| Zeros (%) | 66.4% |
| Memory size | 14.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 607.10065 |
| 95-th percentile | 830.76935 |
| Maximum | 4601.184 |
| Range | 4601.184 |
| Interquartile range (IQR) | 607.10065 |
Descriptive statistics
| Standard deviation | 397.5000546 |
|---|---|
| Coefficient of variation (CV) | 1.733917562 |
| Kurtosis | 17.14266224 |
| Mean | 229.2496849 |
| Median Absolute Deviation (MAD) | 317.5420229 |
| Skewness | 2.858166967 |
| Sum | 410815.4353 |
| Variance | 158006.2934 |
| Value | Count | Frequency (%) | |
| 0 | 1193 | 66.4% | |
| 54.776 | 29 | 1.6% | |
| 693.82935 | 19 | 1.1% | |
| 666.44135 | 16 | 0.9% | |
| 698.394 | 15 | 0.8% | |
| 684.7 | 15 | 0.8% | |
| 657.312 | 14 | 0.8% | |
| 739.476 | 14 | 0.8% | |
| 50.211334 | 13 | 0.7% | |
| 639.05334 | 11 | 0.6% | |
| Other values (144) | 453 | 25.2% |
| Value | Count | Frequency (%) | |
| 0 | 1193 | 66.4% | |
| 18.258667 | 1 | 0.1% | |
| 22.823334 | 1 | 0.1% | |
| 31.952667 | 1 | 0.1% | |
| 36.517334 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 4601.184 | 1 | 0.1% | |
| 3135.926 | 1 | 0.1% | |
| 3085.7146 | 1 | 0.1% | |
| 3044.6326 | 1 | 0.1% | |
| 3021.8093 | 1 | 0.1% |
| Distinct count | 759 |
|---|---|
| Unique (%) | 42.4% |
| Missing | 4 |
| Missing (%) | 0.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.937077009 |
|---|---|
| Minimum | -30.669 |
| Maximum | 39.884 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 14.2 KiB |
Quantile statistics
| Minimum | -30.669 |
|---|---|
| 5-th percentile | -20.705 |
| Q1 | 5.651 |
| median | 6.9505 |
| Q3 | 10.819 |
| 95-th percentile | 17.21595 |
| Maximum | 39.884 |
| Range | 70.553 |
| Interquartile range (IQR) | 5.168 |
Descriptive statistics
| Standard deviation | 10.7752736 |
|---|---|
| Coefficient of variation (CV) | 1.814912217 |
| Kurtosis | 2.040136857 |
| Mean | 5.937077009 |
| Median Absolute Deviation (MAD) | 6.582283452 |
| Skewness | -1.432321471 |
| Sum | 10639.242 |
| Variance | 116.1065211 |
| Value | Count | Frequency (%) | |
| 5.666 | 13 | 0.7% | |
| 6.398 | 13 | 0.7% | |
| 6.367 | 12 | 0.7% | |
| 6.118 | 12 | 0.7% | |
| 5.853 | 11 | 0.6% | |
| 5.682 | 11 | 0.6% | |
| 5.806 | 11 | 0.6% | |
| 5.604 | 11 | 0.6% | |
| 6.429 | 10 | 0.6% | |
| 6.258 | 10 | 0.6% | |
| Other values (749) | 1678 | 93.4% |
| Value | Count | Frequency (%) | |
| -30.669 | 1 | 0.1% | |
| -22.994 | 1 | 0.1% | |
| -21.935 | 1 | 0.1% | |
| -21.842 | 3 | 0.2% | |
| -21.826 | 2 | 0.1% |
| Value | Count | Frequency (%) | |
| 39.884 | 1 | 0.1% | |
| 39.526 | 1 | 0.1% | |
| 35.525 | 1 | 0.1% | |
| 34.17 | 1 | 0.1% | |
| 31.446 | 1 | 0.1% |
| Distinct count | 1347 |
|---|---|
| Unique (%) | 75.3% |
| Missing | 6 |
| Missing (%) | 0.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 27.35474875 |
|---|---|
| Minimum | 0 |
| Maximum | 100 |
| Zeros | 345 |
| Zeros (%) | 19.2% |
| Memory size | 14.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 5.2597287 |
| median | 16.888588 |
| Q3 | 59.750595 |
| 95-th percentile | 70.8707848 |
| Maximum | 100 |
| Range | 100 |
| Interquartile range (IQR) | 54.4908663 |
Descriptive statistics
| Standard deviation | 27.16136763 |
|---|---|
| Coefficient of variation (CV) | 0.9929306197 |
| Kurtosis | -1.168618442 |
| Mean | 27.35474875 |
| Median Absolute Deviation (MAD) | 24.27055222 |
| Skewness | 0.6622308092 |
| Sum | 48965.00026 |
| Variance | 737.7398913 |
| Value | Count | Frequency (%) | |
| 0 | 345 | 19.2% | |
| 100 | 7 | 0.4% | |
| 32.92249 | 2 | 0.1% | |
| 7.1315656 | 2 | 0.1% | |
| 10.962415 | 2 | 0.1% | |
| 68.82789 | 2 | 0.1% | |
| 53.048347 | 2 | 0.1% | |
| 64.46222 | 2 | 0.1% | |
| 17.33208 | 2 | 0.1% | |
| 70.56677 | 2 | 0.1% | |
| Other values (1337) | 1422 | 79.2% | |
| (Missing) | 6 | 0.3% |
| Value | Count | Frequency (%) | |
| 0 | 345 | 19.2% | |
| 1.4e-45 | 1 | 0.1% | |
| 8.4e-45 | 1 | 0.1% | |
| 6.22e-43 | 1 | 0.1% | |
| 7.59e-42 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 100 | 7 | 0.4% | |
| 72.93336 | 1 | 0.1% | |
| 72.85063 | 1 | 0.1% | |
| 72.82571 | 1 | 0.1% | |
| 72.79876 | 1 | 0.1% |
| Distinct count | 1435 |
|---|---|
| Unique (%) | 80.2% |
| Missing | 6 |
| Missing (%) | 0.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -85898.50775 |
|---|---|
| Minimum | -507709.34 |
| Maximum | 284.32373 |
| Zeros | 6 |
| Zeros (%) | 0.3% |
| Memory size | 14.2 KiB |
Quantile statistics
| Minimum | -507709.34 |
|---|---|
| 5-th percentile | -423014.511 |
| Q1 | -81394.2525 |
| median | -23518.402 |
| Q3 | -1990.8225 |
| 95-th percentile | 74.0339055 |
| Maximum | 284.32373 |
| Range | 507993.6637 |
| Interquartile range (IQR) | 79403.43 |
Descriptive statistics
| Standard deviation | 136283.6912 |
|---|---|
| Coefficient of variation (CV) | -1.586566458 |
| Kurtosis | 1.65231096 |
| Mean | -85898.50775 |
| Median Absolute Deviation (MAD) | 104491.6907 |
| Skewness | -1.730377028 |
| Sum | -153758328.9 |
| Variance | 1.857324448e+10 |
| Value | Count | Frequency (%) | |
| 74.0334 | 16 | 0.9% | |
| 74.03337 | 13 | 0.7% | |
| 74.03339 | 13 | 0.7% | |
| 74.03334 | 9 | 0.5% | |
| 74.03333 | 9 | 0.5% | |
| 74.03344 | 9 | 0.5% | |
| 74.03343 | 8 | 0.4% | |
| 74.033325 | 8 | 0.4% | |
| 74.033356 | 8 | 0.4% | |
| 74.03336 | 8 | 0.4% | |
| Other values (1425) | 1689 | 94.0% |
| Value | Count | Frequency (%) | |
| -507709.34 | 1 | 0.1% | |
| -506849.94 | 1 | 0.1% | |
| -505704.06 | 1 | 0.1% | |
| -504749.16 | 1 | 0.1% | |
| -503698.78 | 2 | 0.1% |
| Value | Count | Frequency (%) | |
| 284.32373 | 1 | 0.1% | |
| 225.2503 | 1 | 0.1% | |
| 170.0683 | 2 | 0.1% | |
| 74.035065 | 1 | 0.1% | |
| 74.0344 | 2 | 0.1% |
| Distinct count | 648 |
|---|---|
| Unique (%) | 36.2% |
| Missing | 6 |
| Missing (%) | 0.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 40.58939055 |
|---|---|
| Minimum | 0 |
| Maximum | 660.4863 |
| Zeros | 321 |
| Zeros (%) | 17.9% |
| Memory size | 14.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 46.67148775 |
| median | 46.819499 |
| Q3 | 58.45908225 |
| 95-th percentile | 58.55753665 |
| Maximum | 660.4863 |
| Range | 660.4863 |
| Interquartile range (IQR) | 11.7875945 |
Descriptive statistics
| Standard deviation | 30.0914871 |
|---|---|
| Coefficient of variation (CV) | 0.7413633634 |
| Kurtosis | 199.7636526 |
| Mean | 40.58939055 |
| Median Absolute Deviation (MAD) | 17.90819495 |
| Skewness | 9.309230617 |
| Sum | 72655.00909 |
| Variance | 905.4975957 |
| Value | Count | Frequency (%) | |
| 0 | 321 | 17.9% | |
| 0.000601 | 70 | 3.9% | |
| 46.807777 | 11 | 0.6% | |
| 46.806576 | 11 | 0.6% | |
| 46.80898 | 11 | 0.6% | |
| 46.811386 | 11 | 0.6% | |
| 46.80718 | 10 | 0.6% | |
| 46.80357 | 10 | 0.6% | |
| 58.512127 | 9 | 0.5% | |
| 46.813187 | 8 | 0.4% | |
| Other values (638) | 1318 | 73.4% |
| Value | Count | Frequency (%) | |
| 0 | 321 | 17.9% | |
| 0.000601 | 70 | 3.9% | |
| 0.003606332 | 1 | 0.1% | |
| 0.5885533 | 1 | 0.1% | |
| 8.571649 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 660.4863 | 1 | 0.1% | |
| 660.4662 | 1 | 0.1% | |
| 58.670807 | 1 | 0.1% | |
| 58.663593 | 2 | 0.1% | |
| 58.658184 | 1 | 0.1% |
| Distinct count | 11 |
|---|---|
| Unique (%) | 0.6% |
| Missing | 6 |
| Missing (%) | 0.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -39028.21776 |
|---|---|
| Minimum | -57294 |
| Maximum | 0.5885533 |
| Zeros | 324 |
| Zeros (%) | 18.0% |
| Memory size | 14.2 KiB |
Quantile statistics
| Minimum | -57294 |
|---|---|
| 5-th percentile | -57294 |
| Q1 | -57294 |
| median | -45835.2 |
| Q3 | -45835.2 |
| 95-th percentile | 0 |
| Maximum | 0.5885533 |
| Range | 57294.58855 |
| Interquartile range (IQR) | 11458.8 |
Descriptive statistics
| Standard deviation | 21389.57646 |
|---|---|
| Coefficient of variation (CV) | -0.5480541435 |
| Kurtosis | -0.3840305674 |
| Mean | -39028.21776 |
| Median Absolute Deviation (MAD) | 17295.78824 |
| Skewness | 1.147511947 |
| Sum | -69860509.79 |
| Variance | 457513981.1 |
| Value | Count | Frequency (%) | |
| -45835.2 | 868 | 48.3% | |
| -57294 | 524 | 29.2% | |
| 0 | 324 | 18.0% | |
| -0.5885533 | 35 | 1.9% | |
| 0.5885533 | 33 | 1.8% | |
| -3.5313199 | 1 | 0.1% | |
| 0.013532639 | 1 | 0.1% | |
| 0.009021759 | 1 | 0.1% | |
| -9121.435 | 1 | 0.1% | |
| -34855.695 | 1 | 0.1% | |
| (Missing) | 6 | 0.3% |
| Value | Count | Frequency (%) | |
| -57294 | 524 | 29.2% | |
| -45835.2 | 868 | 48.3% | |
| -34855.695 | 1 | 0.1% | |
| -9518.378 | 1 | 0.1% | |
| -9121.435 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 0.5885533 | 33 | 1.8% | |
| 0.013532639 | 1 | 0.1% | |
| 0.009021759 | 1 | 0.1% | |
| 0 | 324 | 18.0% | |
| -0.5885533 | 35 | 1.9% |
| Distinct count | 921 |
|---|---|
| Unique (%) | 51.5% |
| Missing | 6 |
| Missing (%) | 0.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -19.26698674 |
|---|---|
| Minimum | -55.125 |
| Maximum | 13.412109 |
| Zeros | 395 |
| Zeros (%) | 22.0% |
| Memory size | 14.2 KiB |
Quantile statistics
| Minimum | -55.125 |
|---|---|
| 5-th percentile | -52.7425051 |
| Q1 | -43.894409 |
| median | -9.310547 |
| Q3 | -3.8759766 |
| 95-th percentile | 0 |
| Maximum | 13.412109 |
| Range | 68.537109 |
| Interquartile range (IQR) | 40.0184324 |
Descriptive statistics
| Standard deviation | 20.20963861 |
|---|---|
| Coefficient of variation (CV) | -1.048925755 |
| Kurtosis | -1.244101295 |
| Mean | -19.26698674 |
| Median Absolute Deviation (MAD) | 18.21800991 |
| Skewness | -0.6907447594 |
| Sum | -34487.90626 |
| Variance | 408.4294928 |
| Value | Count | Frequency (%) | |
| 0 | 395 | 22.0% | |
| -3.8862305 | 19 | 1.1% | |
| -3.8964844 | 18 | 1.0% | |
| -3.8759766 | 18 | 1.0% | |
| -3.9067383 | 12 | 0.7% | |
| -3.8657227 | 12 | 0.7% | |
| -3.927246 | 10 | 0.6% | |
| -3.9169922 | 10 | 0.6% | |
| -3.8554688 | 9 | 0.5% | |
| -3.947754 | 9 | 0.5% | |
| Other values (911) | 1278 | 71.2% |
| Value | Count | Frequency (%) | |
| -55.125 | 1 | 0.1% | |
| -54.909668 | 1 | 0.1% | |
| -54.78662 | 1 | 0.1% | |
| -54.612305 | 1 | 0.1% | |
| -54.55078 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 13.412109 | 1 | 0.1% | |
| 7.5776367 | 1 | 0.1% | |
| 6.9624023 | 1 | 0.1% | |
| 0 | 395 | 22.0% | |
| -3.8041992 | 1 | 0.1% |
| Distinct count | 782 |
|---|---|
| Unique (%) | 43.7% |
| Missing | 6 |
| Missing (%) | 0.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9398.196934 |
|---|---|
| Minimum | -3684.58 |
| Maximum | 26062.842 |
| Zeros | 393 |
| Zeros (%) | 21.9% |
| Memory size | 14.2 KiB |
Quantile statistics
| Minimum | -3684.58 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1827.7838 |
| median | 5401.1495 |
| Q3 | 20746.31225 |
| 95-th percentile | 24917.3356 |
| Maximum | 26062.842 |
| Range | 29747.422 |
| Interquartile range (IQR) | 18918.52845 |
Descriptive statistics
| Standard deviation | 9412.472807 |
|---|---|
| Coefficient of variation (CV) | 1.001519001 |
| Kurtosis | -1.244046562 |
| Mean | 9398.196934 |
| Median Absolute Deviation (MAD) | 8405.189856 |
| Skewness | 0.6485643645 |
| Sum | 16822772.51 |
| Variance | 88594644.35 |
| Value | Count | Frequency (%) | |
| 0 | 393 | 21.9% | |
| 1837.4546 | 35 | 1.9% | |
| 1827.7838 | 32 | 1.8% | |
| 1847.1254 | 23 | 1.3% | |
| 1818.1129 | 15 | 0.8% | |
| 1856.7963 | 14 | 0.8% | |
| 1866.467 | 13 | 0.7% | |
| 5396.314 | 9 | 0.5% | |
| 2504.7407 | 9 | 0.5% | |
| 1808.4421 | 8 | 0.4% | |
| Other values (772) | 1239 | 69.0% |
| Value | Count | Frequency (%) | |
| -3684.58 | 1 | 0.1% | |
| -2939.9272 | 1 | 0.1% | |
| -1702.0632 | 1 | 0.1% | |
| -7.6068115 | 1 | 0.1% | |
| -6.257324 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 26062.842 | 1 | 0.1% | |
| 25956.463 | 1 | 0.1% | |
| 25898.44 | 1 | 0.1% | |
| 25811.402 | 1 | 0.1% | |
| 25792.06 | 1 | 0.1% |
| Distinct count | 937 |
|---|---|
| Unique (%) | 52.3% |
| Missing | 6 |
| Missing (%) | 0.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -27.34447933 |
|---|---|
| Minimum | -78.144 |
| Maximum | 19.026 |
| Zeros | 395 |
| Zeros (%) | 22.0% |
| Memory size | 14.2 KiB |
Quantile statistics
| Minimum | -78.144 |
|---|---|
| 5-th percentile | -74.921 |
| Q1 | -62.214 |
| median | -13.174 |
| Q3 | -5.501 |
| 95-th percentile | 0 |
| Maximum | 19.026 |
| Range | 97.17 |
| Interquartile range (IQR) | 56.713 |
Descriptive statistics
| Standard deviation | 28.67744011 |
|---|---|
| Coefficient of variation (CV) | -1.04874698 |
| Kurtosis | -1.244317714 |
| Mean | -27.34447933 |
| Median Absolute Deviation (MAD) | 25.85522116 |
| Skewness | -0.6901795843 |
| Sum | -48946.618 |
| Variance | 822.395571 |
| Value | Count | Frequency (%) | |
| 0 | 395 | 22.0% | |
| -5.514 | 18 | 1.0% | |
| -5.501 | 18 | 1.0% | |
| -5.474 | 13 | 0.7% | |
| -5.541 | 13 | 0.7% | |
| -5.487 | 12 | 0.7% | |
| -5.528 | 12 | 0.7% | |
| -5.555 | 10 | 0.6% | |
| -5.569 | 10 | 0.6% | |
| -5.609 | 9 | 0.5% | |
| Other values (927) | 1280 | 71.3% |
| Value | Count | Frequency (%) | |
| -78.144 | 1 | 0.1% | |
| -78.036 | 1 | 0.1% | |
| -77.764 | 1 | 0.1% | |
| -77.398 | 1 | 0.1% | |
| -77.33 | 2 | 0.1% |
| Value | Count | Frequency (%) | |
| 19.026 | 1 | 0.1% | |
| 10.742 | 1 | 0.1% | |
| 9.886 | 1 | 0.1% | |
| 0 | 395 | 22.0% | |
| -5.406 | 1 | 0.1% |
| Distinct count | 623 |
|---|---|
| Unique (%) | 34.8% |
| Missing | 6 |
| Missing (%) | 0.3% |
| Memory size | 14.2 KiB |
| 1.0742188 | 13 |
|---|---|
| 0.07324219 | 12 |
| 0.17700195 | 12 |
| 1.1169434 | 10 |
| 0.29296875 | 10 |
| Other values (618) |
| Value | Count | Frequency (%) | |
| 1.0742188 | 13 | 0.7% | |
| 0.07324219 | 12 | 0.7% | |
| 0.17700195 | 12 | 0.7% | |
| 1.1169434 | 10 | 0.6% | |
| 0.29296875 | 10 | 0.6% | |
| 1.763916 | 10 | 0.6% | |
| 0.8911133 | 9 | 0.5% | |
| 0.88500977 | 9 | 0.5% | |
| 0.14648438 | 9 | 0.5% | |
| 0.13427734 | 9 | 0.5% | |
| Other values (613) | 1687 | 93.9% |
Length
| Max length | 24 |
|---|---|
| Mean length | 9.04454343 |
| Min length | 1 |
| Value | Count | Frequency (%) | |
| Decimal_Number | 10 | 58.8% | |
| Other_Punctuation | 2 | 11.8% | |
| Lowercase_Letter | 2 | 11.8% | |
| Uppercase_Letter | 2 | 11.8% | |
| Dash_Punctuation | 1 | 5.9% |
| Value | Count | Frequency (%) | |
| Common | 13 | 76.5% | |
| Latin | 4 | 23.5% |
| Value | Count | Frequency (%) | |
| ASCII | 17 | 100.0% |
| Distinct count | 1246 |
|---|---|
| Unique (%) | 69.6% |
| Missing | 6 |
| Missing (%) | 0.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 382.9619169 |
|---|---|
| Minimum | 0 |
| Maximum | 650.30963 |
| Zeros | 5 |
| Zeros (%) | 0.3% |
| Memory size | 14.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 266.182187 |
| Q1 | 266.4203575 |
| median | 324.87103 |
| Q3 | 374.97296 |
| 95-th percentile | 650.249369 |
| Maximum | 650.30963 |
| Range | 650.30963 |
| Interquartile range (IQR) | 108.5526025 |
Descriptive statistics
| Standard deviation | 148.3388379 |
|---|---|
| Coefficient of variation (CV) | 0.3873461861 |
| Kurtosis | -0.3433131288 |
| Mean | 382.9619169 |
| Median Absolute Deviation (MAD) | 120.7428778 |
| Skewness | 1.078836308 |
| Sum | 685501.8313 |
| Variance | 22004.41084 |
| Value | Count | Frequency (%) | |
| 650.24225 | 16 | 0.9% | |
| 324.8704 | 11 | 0.6% | |
| 324.86975 | 11 | 0.6% | |
| 650.2419 | 10 | 0.6% | |
| 324.87003 | 10 | 0.6% | |
| 650.2434 | 9 | 0.5% | |
| 324.87045 | 9 | 0.5% | |
| 324.87033 | 9 | 0.5% | |
| 324.87006 | 9 | 0.5% | |
| 324.8701 | 8 | 0.4% | |
| Other values (1236) | 1688 | 94.0% |
| Value | Count | Frequency (%) | |
| 0 | 5 | 0.3% | |
| 0.009765625 | 2 | 0.1% | |
| 266.14133 | 1 | 0.1% | |
| 266.14282 | 1 | 0.1% | |
| 266.1446 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 650.30963 | 1 | 0.1% | |
| 650.29016 | 1 | 0.1% | |
| 650.288 | 1 | 0.1% | |
| 650.2828 | 1 | 0.1% | |
| 650.2787 | 1 | 0.1% |
| Distinct count | 163 |
|---|---|
| Unique (%) | 9.1% |
| Missing | 6 |
| Missing (%) | 0.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.440822497 |
|---|---|
| Minimum | 0 |
| Maximum | 100.27344 |
| Zeros | 250 |
| Zeros (%) | 13.9% |
| Memory size | 14.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0.009765625 |
| median | 0.13671875 |
| Q3 | 0.3515625 |
| 95-th percentile | 0.95703125 |
| Maximum | 100.27344 |
| Range | 100.27344 |
| Interquartile range (IQR) | 0.341796875 |
Descriptive statistics
| Standard deviation | 14.15607324 |
|---|---|
| Coefficient of variation (CV) | 5.79971434 |
| Kurtosis | 40.55874765 |
| Mean | 2.440822497 |
| Median Absolute Deviation (MAD) | 4.3192206 |
| Skewness | 6.466731389 |
| Sum | 4369.07227 |
| Variance | 200.3944095 |
| Value | Count | Frequency (%) | |
| 0 | 250 | 13.9% | |
| 0.009765625 | 243 | 13.5% | |
| 0.01953125 | 51 | 2.8% | |
| 0.087890625 | 44 | 2.4% | |
| 0.12695312 | 37 | 2.1% | |
| 0.078125 | 36 | 2.0% | |
| 0.16601562 | 35 | 1.9% | |
| 0.0390625 | 35 | 1.9% | |
| 0.13671875 | 33 | 1.8% | |
| 0.15625 | 31 | 1.7% | |
| Other values (153) | 995 | 55.4% |
| Value | Count | Frequency (%) | |
| 0 | 250 | 13.9% | |
| 0.009765625 | 243 | 13.5% | |
| 0.01953125 | 51 | 2.8% | |
| 0.029296875 | 26 | 1.4% | |
| 0.0390625 | 35 | 1.9% |
| Value | Count | Frequency (%) | |
| 100.27344 | 1 | 0.1% | |
| 100.21484 | 1 | 0.1% | |
| 100.20508 | 1 | 0.1% | |
| 100.18555 | 1 | 0.1% | |
| 100.166016 | 2 | 0.1% |
| Distinct count | 610 |
|---|---|
| Unique (%) | 34.1% |
| Missing | 6 |
| Missing (%) | 0.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.613457162 |
|---|---|
| Minimum | -6.91864 |
| Maximum | 1248 |
| Zeros | 19 |
| Zeros (%) | 1.1% |
| Memory size | 14.2 KiB |
Quantile statistics
| Minimum | -6.91864 |
|---|---|
| 5-th percentile | -0.513885487 |
| Q1 | -0.05218506 |
| median | 0.2746582 |
| Q3 | 0.5548096 |
| 95-th percentile | 0.9036255 |
| Maximum | 1248 |
| Range | 1254.91864 |
| Interquartile range (IQR) | 0.60699466 |
Descriptive statistics
| Standard deviation | 41.70306511 |
|---|---|
| Coefficient of variation (CV) | 25.84702346 |
| Kurtosis | 891.9790395 |
| Mean | 1.613457162 |
| Median Absolute Deviation (MAD) | 2.823326559 |
| Skewness | 29.87847993 |
| Sum | 2888.088319 |
| Variance | 1739.14564 |
| Value | Count | Frequency (%) | |
| 0 | 19 | 1.1% | |
| -0.01373291 | 12 | 0.7% | |
| 0.4147339 | 12 | 0.7% | |
| 0.4586792 | 11 | 0.6% | |
| -0.019226074 | 10 | 0.6% | |
| 0.29663086 | 10 | 0.6% | |
| -0.15655518 | 9 | 0.5% | |
| 0.05218506 | 9 | 0.5% | |
| 0.5932617 | 9 | 0.5% | |
| 0.40100098 | 8 | 0.4% | |
| Other values (600) | 1681 | 93.6% |
| Value | Count | Frequency (%) | |
| -6.91864 | 1 | 0.1% | |
| -5.7540894 | 2 | 0.1% | |
| -4.817505 | 1 | 0.1% | |
| -4.430237 | 1 | 0.1% | |
| -4.0759277 | 2 | 0.1% |
| Value | Count | Frequency (%) | |
| 1248 | 2 | 0.1% | |
| 6.303406 | 1 | 0.1% | |
| 5.869446 | 1 | 0.1% | |
| 5.836487 | 1 | 0.1% | |
| 5.809021 | 1 | 0.1% |
| Distinct count | 615 |
|---|---|
| Unique (%) | 34.4% |
| Missing | 6 |
| Missing (%) | 0.3% |
| Memory size | 14.2 KiB |
| 0 | 17 |
|---|---|
| 0.521 | 11 |
| -0.138 | 10 |
| 0.642 | 9 |
| 0.021 | 9 |
| Other values (610) |
| Value | Count | Frequency (%) | |
| 0 | 17 | 0.9% | |
| 0.521 | 11 | 0.6% | |
| -0.138 | 10 | 0.6% | |
| 0.642 | 9 | 0.5% | |
| 0.021 | 9 | 0.5% | |
| 0.03 | 9 | 0.5% | |
| -0.02 | 9 | 0.5% | |
| -0.13 | 9 | 0.5% | |
| 0.401 | 9 | 0.5% | |
| 0.362 | 8 | 0.4% | |
| Other values (605) | 1690 | 94.1% |
Length
| Max length | 6 |
|---|---|
| Mean length | 5.139198218 |
| Min length | 1 |
| Value | Count | Frequency (%) | |
| Decimal_Number | 10 | 55.6% | |
| Uppercase_Letter | 4 | 22.2% | |
| Lowercase_Letter | 2 | 11.1% | |
| Other_Punctuation | 1 | 5.6% | |
| Dash_Punctuation | 1 | 5.6% |
| Value | Count | Frequency (%) | |
| Common | 12 | 66.7% | |
| Latin | 6 | 33.3% |
| Value | Count | Frequency (%) | |
| ASCII | 18 | 100.0% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
First rows
| SPB1__Motor__Temperature | C1__Axis__Actual_Feed_Rate | C1__Axis__Drive_Load | C1__Axis__Position | C1__Axis__Rotary_Speed | C1__Axis__Speed | C1__Motor__Current | C1__Motor__Power | C1__Motor__Torque | SPB1__Axis__Drive_Load | SPB1__Axis__Position | SPB1__Axis__Rotary_Speed | SPB1__Axis__Speed | SPB1__Motor__Current | SPB1__Motor__Power | SPB1__Motor__Torque | X__Axis__Drive_Load | X__Axis__Position | X__Axis__Rotary_Speed | X__Motor__Current | X__Motor__Torque | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 59.610542 | -3819.5996 | 4.864502 | -564.14940 | 24.245382 | -3819.5996 | 4.498901 | 698.39400 | 8.811 | 7.243908 | -8768.372 | 58.515133 | -57294.0 | -4.275879 | 2524.0823 | -6.071 | 0.80566406 | 266.18870 | 0.009766 | 0.216980 | 0.216 |
| 1 | 59.34928 | -3819.5996 | 5.377197 | -627.80945 | 24.256876 | -3819.5996 | 4.498901 | 698.39400 | 9.714 | 7.220807 | -9818.762 | 58.510323 | -57294.0 | -4.255371 | 2514.4116 | -6.030 | 2.972412 | 266.15970 | 0.009766 | 0.802002 | 0.802 |
| 2 | 59.367516 | -3819.5996 | 5.529785 | -672.37146 | 24.250746 | -3819.5996 | 4.556030 | 702.95870 | 9.184 | 7.200350 | -10391.702 | 58.503110 | -57294.0 | -4.245117 | 2504.7407 | -6.003 | 3.930664 | 266.14877 | 0.009766 | 1.057434 | 1.06 |
| 3 | 59.269466 | -3819.5996 | 5.432129 | -736.03143 | 24.249979 | -3819.5996 | 4.656005 | 721.21735 | 9.542 | 7.185362 | -11346.602 | 58.504314 | -57294.0 | -4.234863 | 2504.7407 | -6.058 | 4.095459 | 266.14133 | 0.019531 | 1.106873 | 1.106 |
| 4 | 59.209194 | -3819.5996 | 5.114746 | -806.05740 | 24.258154 | -3819.5996 | 4.598877 | 712.08800 | 11.224 | 7.207621 | -12396.992 | 58.510323 | -57294.0 | -4.286133 | 2514.4116 | -6.058 | 1.8005371 | 266.14460 | 0.019531 | 0.491638 | 0.486 |
| 5 | 59.14919 | -3819.5996 | 5.114746 | -876.08325 | 24.244871 | -3819.5996 | 4.977355 | 771.42865 | 9.387 | 7.225293 | -13447.382 | 58.515730 | -57294.0 | -4.286133 | 2524.0823 | -6.071 | 1.4343262 | 266.14966 | 0.039062 | 0.387268 | 0.384 |
| 6 | 59.2493 | -3819.5996 | 4.785156 | -939.74335 | 24.244616 | -3819.5996 | 4.577453 | 707.52330 | 8.390 | 7.256448 | -14402.281 | 58.511524 | -57294.0 | -4.286133 | 2533.7532 | -6.098 | 1.2207031 | 266.15335 | 0.009766 | 0.326843 | 0.326 |
| 7 | 59.2493 | -3819.5996 | 5.566406 | -1003.40320 | 24.241550 | -3819.5996 | 4.998779 | 775.99335 | 9.574 | 7.250866 | -15357.182 | 58.509724 | -57294.0 | -4.286133 | 2533.7532 | -6.085 | 1.0009766 | 266.15640 | 0.009766 | 0.269165 | 0.269 |
| 8 | 59.116924 | -3819.5996 | 3.918457 | -1079.79550 | 24.247936 | -3819.5996 | 3.670532 | 566.01870 | 8.531 | 7.236337 | -16503.062 | 58.512730 | -57294.0 | -4.296387 | 2533.7532 | -6.098 | 0.6286621 | 266.15942 | 0.009766 | 0.173035 | 0.167 |
| 9 | 59.219067 | -3819.5996 | 5.120850 | -1149.82130 | 24.247936 | -3819.5996 | 4.891662 | 757.73470 | 9.044 | 7.252181 | -17553.451 | 58.510323 | -57294.0 | -4.306641 | 2543.4240 | -6.112 | 0.4272461 | 266.16177 | 0.000000 | 0.118103 | 0.115 |
Last rows
| SPB1__Motor__Temperature | C1__Axis__Actual_Feed_Rate | C1__Axis__Drive_Load | C1__Axis__Position | C1__Axis__Rotary_Speed | C1__Axis__Speed | C1__Motor__Current | C1__Motor__Power | C1__Motor__Torque | SPB1__Axis__Drive_Load | SPB1__Axis__Position | SPB1__Axis__Rotary_Speed | SPB1__Axis__Speed | SPB1__Motor__Current | SPB1__Motor__Power | SPB1__Motor__Torque | X__Axis__Drive_Load | X__Axis__Position | X__Axis__Rotary_Speed | X__Motor__Current | X__Motor__Torque | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1786 | 62.043728 | 0.0 | 3.039551 | 24.000004 | 0.000255 | 0.0 | 2.663635 | 0.0 | 5.775 | 60.878390 | -30288.746 | 46.858868 | -45835.2 | -43.609863 | 20618.174 | -61.902 | 1.4343262 | 324.87924 | 0.312500 | 0.381775 | 0.387 |
| 1787 | 61.75533 | 0.0 | 3.442383 | 24.000002 | 0.003321 | 0.0 | 2.735046 | 0.0 | 6.756 | 60.165062 | -31205.455 | 46.747673 | -45835.2 | -48.911133 | 23113.244 | -69.602 | 1.4465332 | 324.87890 | 0.439453 | 0.390015 | 0.406 |
| 1788 | 62.098343 | 0.0 | 3.326416 | 24.000008 | 0.002299 | 0.0 | 2.763610 | 0.0 | 6.367 | 64.986290 | -31816.588 | 46.650900 | -45835.2 | -47.475586 | 22436.287 | -67.484 | 2.6367188 | 324.87400 | 0.771484 | 0.670166 | 0.716 |
| 1789 | 61.7932 | 0.0 | 3.094482 | 24.000010 | 0.002044 | 0.0 | 2.699341 | 0.0 | 6.102 | 65.291990 | -32733.295 | 46.862473 | -45835.2 | -49.259766 | 23287.318 | -69.792 | 2.368164 | 324.87030 | 0.039062 | 0.692139 | 0.626 |
| 1790 | 61.7932 | 0.0 | 2.813721 | 24.000000 | 0.003832 | 0.0 | 2.585083 | 0.0 | 5.651 | 62.597040 | -33649.996 | 46.873894 | -45835.2 | -47.291016 | 22349.250 | -67.035 | 3.6254883 | 324.86893 | 0.400391 | 0.922852 | 0.994 |
| 1791 | 61.808193 | 0.0 | 2.838135 | 23.999998 | 0.002299 | 0.0 | 2.670776 | 0.0 | 5.666 | 60.633305 | -34413.920 | 46.727837 | -45835.2 | -43.507324 | 20560.150 | -61.657 | 1.348877 | 324.87190 | 0.527344 | 0.420227 | 0.409 |
| 1792 | 61.943764 | 0.0 | 3.002930 | 24.000008 | 0.000000 | 0.0 | 2.720764 | 0.0 | 5.868 | 54.151047 | -35254.220 | 46.876900 | -45835.2 | -37.324220 | 17649.234 | -53.020 | 0.75683594 | 324.88718 | 0.214844 | 0.159302 | 0.227 |
| 1793 | 62.221077 | 0.0 | 3.039551 | 23.999987 | 0.002554 | 0.0 | 2.720764 | 0.0 | 5.884 | 50.130196 | -35636.184 | 46.765102 | -45835.2 | -34.248047 | 16198.612 | -48.769 | 0.25634766 | 324.88928 | 1.826172 | 0.159302 | 0.041 |
| 1794 | 61.88034 | 0.0 | 2.471924 | 23.999977 | 0.001788 | 0.0 | 2.527954 | 0.0 | 4.903 | 35.832497 | -36552.900 | 46.760296 | -45835.2 | -22.425293 | 10608.883 | -31.752 | 1.0925293 | 324.89236 | 0.917969 | 0.340576 | 0.274 |
| 1795 | 62.21693 | 0.0 | 2.923584 | 23.999992 | 0.002299 | 0.0 | 2.563659 | 0.0 | 5.682 | 21.951164 | -37316.810 | 46.945420 | -45835.2 | -12.848145 | 6082.942 | -18.185 | 0.76904297 | 324.89487 | 0.380859 | 0.203247 | 0.203 |